Oracle® Retail
Integration Cloud Service
Release
Notes
Release
16.0.027
E97078-01
May 2018
This document highlights the
major changes in this release of Oracle Retail Integration Cloud Service.
Overview
The Oracle Retail Integration
Cloud Service is comprised of the Oracle Retail Integration Suite of products
that are cloud deployable for a customer’s integration to Oracle Retail
applications, and the customer’s on-premises or hybrid configurations of
third-party applications.
The integration products
supported are the same as the generally-available on premises versions of the
Oracle Retail Integration Bus (RIB), the Oracle Retail Service Backbone (RSB)
and Oracle Retail Bulk Data Integration (BDI).
The cloud-deployed versions
of the integration products render some functionality and documentation not
applicable. For example, installation documentation is not provided in this
release because those activities are handled by the cloud provider. In
addition, customization tooling documentation is no longer available because
those activities are no longer supported.
In a few documents, minor
changes in configuration are noted. See the section, Related Documentation,
later in this document for the complete list of documents associated with this
release.
Note The Oracle Retail
Integration Cloud Service application is based on corresponding on-premises
applications. References to the on-premises application names exist
throughout the application and documents. |
Note The non-sequential
version number of this Oracle Retail application is intentional. |
Oracle Retail Cloud Services
and Business Agility
Oracle Retail Integration Bus
Cloud Service is hosted in the Oracle Cloud with the security features inherent
to Oracle technology and a robust data center classification, providing
significant uptime. The Oracle Cloud team is responsible for installing, monitoring,
patching, and upgrading retail software.
Included in the service is
continuous technical support, access to software feature enhancements, hardware
upgrades, and disaster recovery. The Cloud Service model helps to free customer
IT resources from the need to perform these tasks, giving retailers greater
business agility to respond to changing technologies and to perform more
value-added tasks focused on business processes and innovation.
Oracle Retail Software Cloud
Service is acquired exclusively through a subscription service (SaaS) model.
This shifts funding from a capital investment in software to an operational
expense. Subscription-based pricing for retail applications offers flexibility
and cost effectiveness.
A Note about On-Premises
Applications and Integration Cloud Service Support
The integration between the
Oracle Retail Integration Cloud Service and the Oracle Retail on-premises
applications below is not supported. Any mention of those applications that may
exist within this documentation set is for reference purposes only.
n
Oracle Retail Warehouse Management System
(RWMS)
n
Oracle Retail Advanced Inventory System
(AIP)
n
Oracle Retail Price Management (RPM)
Note RPM and the Pricing
module that is included in the Merchandising Cloud Services release are
separate entities, and RPM in this list is not a reference to that Pricing
module. |
Note that in some cases third
party applications can communicate with the RIB using services.
Client System Requirements
The following technology is
supported:
n
Operating
Systems
-
Microsoft
Windows 7
-
Microsoft
Windows 10
n
Browser
Support
-
Mozilla Firefox ESR 52+
-
Internet Explorer 11.0
-
Google Chrome (Desktop) 55+
Note Oracle Retail assumes
that the retailer has ensured its Operating System has been patched with all
applicable Windows updates. |
Technical Enhancements
The technical enhancements
below are included in this release.
Release Summary
The following changes were
made to Oracle Retail Integration Cloud Service:
n
Third Party
.jar upgrades.
n
Introduced
Groups in BDI to enable throttling of Batch Jobs.
n
Performance
tuning by identifying the potential issues and added Indexes where required.
n
Purge scripts
for growing BDI tables.
n
Bug fixes.
BDI/JOS Data Model Changes
Note The information below
is not accessible to the retailer, but is provided for reference purposes. |
There are many changes to
tables and indexes of BDI. The migration script will take care of the database
changes. All the migration scripts must be run from the existing release. All
the migration scripts for any intermediate releases, if any, must be run in
order to make sure that the database objects are consistent with the
application.
Restful API Changes
New RESTful API endpoints are
added for BDI. Please see the BDI Implementation Guide
for more information.
Purge Strategy
Note The information below is
not accessible to the retailer, but is provided for reference purposes. |
The purge scripts help in
removing the old transactional data.
This script can run in two
modes: Silent Mode and Interactive Mode.
Silent
Mode
Execute the procedure without
passing any parameters. It calculates the period and removes the data. By
default it keeps 6 months data and removes older than that.
For example, if someone wants
to keep only 2 months of data and remove the rest of the data, modify the
procedure just by updating variable howManyMonths NUMBER(5) := 6 to the required value:
howManyMonths = 2
Interactive
Mode
Pass the fromDate and toDate parameters to the procedure to purge the specified period of data. Data
will be removed for only specified period (that is, fromDate to toDate.
From and to dates format
should be in following format:
FROMDATE :=
TO_TIMESTAMP('2017-01-01T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS');
TODATE :=
TO_TIMESTAMP('2017-04-30T23:59:59', 'YYYY-MM-DD"T"HH24:MI:SS');
The deleted data will be committed
to default in both silent and interactive modes.
How To
Execute Purge SQL Example
n
Slient Mode
SET SERVEROUTPUT ON;
DECLARE FROMDATE
TIMESTAMP;
TODATE TIMESTAMP;
BEGIN
FROMDATE := NULL;
TODATE := NULL;
BDI_PURGE_SQL.PURGE_JOB_INT_REPO
(FROMDATE => FROMDATE, TODATE => TODATE);
END;
n
Interactive
Mode
SET SERVEROUTPUT ON;
DECLARE
FROMDATE TIMESTAMP;
TODATE TIMESTAMP;
BEGIN
FROMDATE :=
TO_TIMESTAMP ('2017-01-03T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS');
TODATE := TO_TIMESTAMP
('2017-01-03T23:59:59', 'YYYY-MM-DD"T"HH24:MI:SS');
BDI_PURGE_SQL.PURGE_JOB_INT_REPO
(FROMDATE => FROMDATE, TODATE => TODATE);
END;
Data
Removed
The purge SQL removes the
data from the following tables for the respective schemas.
Table
1 (Cont.) Purge Data Removed |
||
Schema Name |
SQL Name |
Table Name |
job-int-schema |
purge_job_int_repo.sql |
BDI_DWNLDR_TRNSMITR_EXE_DSET BDI_DWNLDR_TRNSMITTR_TRANS |
job-rcvr-schema |
purge_job_rcvr_repo.sql |
BDI_RECVR_TRANSMISSION_BLOCK BDI_RECEIVER_TRANSMISSION BDI_RECEIVER_TRANSACTION |
batch-db-schema |
purge_batch_db_repo.sql |
JOBSTATUS STEPSTATUS STEPEXECUTIONINSTANCEDATA EXECUTIONINSTANCEDATA JOBINSTANCEDATA CHECKPOINTDATA |
process-schema |
purge_process_repo.sql |
BDI_ACTIVITY_EXEC_INSTANCE BDI_PROCESS_CALL_STACK BDI_PROCESS_EXEC_INSTANCE |
scheduler schema |
purge_scheduler_repo.sql |
BDI_SCHEDULE_EXECUTION |
Functional Enhancements
There are no functional
enhancements associated with RIB, RSB, and BDI in this release.
Support Considerations
For product support and
logged defects, the product identifier for the Oracle Retail Integration Cloud
Service is 13314. Each logged defect will be analyzed to determine the source
of the reported issue. Note that this Cloud Service product code also includes
RSB and BDI functionality.
Related Documentation
For more information, see the
following documents in the Oracle Retail Integration Cloud Service 16.0.027
documentation set:
RIB Related Documentation
For more information, see the
following documents in the Oracle Retail Integration Bus 16.0.027 documentation
set:
n
Oracle Retail Integration Bus Implementation Guide
n
Oracle Retail Integration Bus Integration Gateway Services Guide
n
Oracle Retail Integration Bus JMS Console Guide
n
Oracle Retail Integration Bus Operations Guide
n
Oracle Retail Integration Bus Hospital Administration Guide
n
Oracle Retail Integration Bus Security Guide
n
Oracle Retail Integration Bus Service-Oriented Architecture Enabler Tool
Guide
n
Oracle Retail Integration Bus Support Tools Guide
n
Oracle Retail Functional Artifacts Guide
n
Oracle Retail Functional Artifacts Generator Guide
RSB Related Documentation
For more information, see the
following documents in the Oracle Retail Service Backbone 16.0.027
documentation set:
n
Oracle Retail Service Backbone Integration Console User Guide
n
Oracle Retail Service Backbone Developer Guide
n
Oracle Retail Service Backbone Integration Console User Guide
n
Oracle Retail Service Backbone Integration Security Guide
Merchandising System Related
Documentation
For more information, see the
following documents in the Merchandising System 16.0.027 documentation set:
n
Oracle Retail
Merchandising System - Operations Guide, Volume 1 - Batch Overviews and Designs
n
Oracle Retail
Merchandising System - Operations Guide, Volume 2 - Message Publication and
Subscription Designs
Oracle Retail Learning
Subscriptions at Oracle University
The Oracle Retail Learning
Subscription is a digital training solution for anyone on your team seeking
training on Oracle Retail Products. With the learning subscription you get the
key elements of an effective learning program and the conveniences of a digital
format, making this training unmatched in the industry.
You get modern learning at
its best, such as:
n
12 months of
24/7 access to a comprehensive set of high quality videos delivered by Oracle
experts.
n
Detailed coverage and step-by-step
demonstrations.
n
Periodic updates for new features and
product enhancements.
n
Flexibility to search, access and learn
about specific topics of interest.
The learning subscription
enables current users to continually refresh and upgrade their product skills.
It also enables new employees with a self-paced learning guide to help them
quickly become proficient on Oracle Retail Products.
For training opportunities,
see the following web site:
http://www.oracle.com/education
Documentation Accessibility
For information about
Oracle's commitment to accessibility, visit the Oracle Accessibility Program
website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have
purchased support have access to electronic support through My Oracle Support.
For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle® Retail
Integration Cloud Service Release Notes, Release 16.0.027
E97078-01
Copyright © 2018,
Oracle and/or its affiliates. All rights reserved.
This software and
related documentation are provided under a license agreement containing
restrictions on use and disclosure and are protected by intellectual property
laws. Except as expressly permitted in your license agreement or allowed by
law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any
form, or by any means. Reverse engineering, disassembly, or decompilation of
this software, unless required by law for interoperability, is prohibited.
The information
contained herein is subject to change without notice and is not warranted to be
error-free. If you find any errors, please report them to us in writing.
If this is software or
related documentation that is delivered to the U.S. Government or anyone
licensing it on behalf of the U.S. Government, then the following notice is
applicable:
U.S. GOVERNMENT END
USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S.
Government end users are "commercial computer software" pursuant to
the applicable Federal Acquisition Regulation and agency-specific supplemental
regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated
software, any programs installed on the hardware, and/or documentation, shall
be subject to license terms and license restrictions applicable to the
programs. No other rights are granted to the U.S. Government.
This software or
hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently
dangerous applications, including applications that may create a risk of
personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe,
backup, redundancy, and other measures to ensure its safe use. Oracle
Corporation and its affiliates disclaim any liability for any damages caused by
use of this software or hardware in dangerous applications.
Oracle and Java are
registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.
Intel and Intel Xeon
are trademarks or registered trademarks of Intel Corporation. All SPARC
trademarks are used under license and are trademarks or registered trademarks
of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron
logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is
a registered trademark of The Open Group.
This software or hardware
and documentation may provide access to or information about content, products,
and services from third parties. Oracle Corporation and its affiliates are not
responsible for and expressly disclaim all warranties of any kind with respect
to third-party content, products, and services unless otherwise set forth in an
applicable agreement between you and Oracle. Oracle Corporation and its
affiliates will not be responsible for any loss, costs, or damages incurred due
to your access to or use of third-party content, products, or services, except
as set forth in an applicable agreement between you and Oracle.
Value-Added
Reseller (VAR) Language
Oracle
Retail VAR Applications
The following
restrictions and provisions only apply to the programs referred to in this
section and licensed to you. You acknowledge that the programs may contain
third party software (VAR applications) licensed to Oracle. Depending upon your
product and its version number, the VAR applications may include:
(i) the MicroStrategy Components developed and licensed by
MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to
Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and
MicroStrategy for Oracle Retail Planning & Optimization applications.
(ii) the Wavelink component developed and licensed by Wavelink
Corporation (Wavelink) of Kirkland, Washington, to Oracle and imbedded in
Oracle Retail Mobile Store Inventory Management.
(iii) the software
component known as Access Via™ licensed by Access Via
of Seattle, Washington, and imbedded in Oracle Retail Signs and Oracle Retail
Labels and Tags.
(iv) the software
component known as Adobe Flex™ licensed by Adobe
Systems Incorporated of San Jose, California, and imbedded in Oracle Retail
Promotion Planning & Optimization application.
You acknowledge and
confirm that Oracle grants you use of only the object code of the VAR
Applications. Oracle will not deliver source code to the VAR Applications to
you. Notwithstanding any other term or condition of the agreement and this
ordering document, you shall not cause or permit alteration of any VAR
Applications. For purposes of this section, "alteration" refers to
all alterations, translations, upgrades, enhancements, customizations or
modifications of all or any portion of the VAR Applications including all
reconfigurations, reassembly or reverse assembly, re-engineering or reverse
engineering and recompilations or reverse compilations of the VAR Applications
or any derivatives of the VAR Applications. You acknowledge that it shall be a
breach of the agreement to utilize the relationship, and/or confidential
information of the VAR Applications for purposes of competitive discovery.
The VAR Applications
contain trade secrets of Oracle and Oracle's licensors and Customer shall not
attempt, cause, or permit the alteration, decompilation, reverse engineering,
disassembly or other reduction of the VAR Applications to a human perceivable
form. Orale reserves the right to replace, with functional equivalent software,
any of the VAR Applications in future releases of the applicable program.